Hello,

The Management server on a six servers configuration failed to access the OnePoint Database server.

2/24/2014 6:24:32 PM

Log SQL Server (Current - 2/24/2014 6:56:00 PM)

Source Logon

Message
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. [CLIENT: xxx.xxx.xxx.xxx]

the six servers are:

OnePoint Database Server

SystemCenterReporting Server

Collection Server

Management Server

Reporting Service Server

Distribution Server

Which permissions is missng?

Thanks,

Hello,

What are the SPN commands to be registered for a six servers architecture FCS environment?

 SOPFCSDB1: Collection Database Server OnePoint

-          SOPFCSRS1: Reporting Server Database SystemCenterReporting

-          VOTFCSMS1: Management Server

-          VOTFCSCS1: Collection Server

-          VOTFCSRS1: Reporting Service Server

Thanks,

Hello,

Hello,

I verified both the user account and the machine account are sysadmin on the SQL Database. But as we are most likely using Kerberos I think I miss a SETSPN command ... I did already the one:

setspn -A MSSQLSvc/SOPFCSDB1.ad.medctr.ucla.edu:1433 AD\svcFFCS
setspn -A MSSQLSvc/SOPFCSDB1:1433 AD\svcFFCS

should I do also

setspn -A MSSQLSvc/SOPFCSDB1.ad.medctr.ucla.edu:1433 AD\VOTFCSCS1$
setspn -A MSSQLSvc/SOPFCSDB1:1433 AD\VOTFCSCS1$

svcFFCS ois the user account and VOTFCSCS1 is the machine account xxx.xxx.xxx.xxx

Thanks,

Dom